import { utils, writeFile } from 'xlsx';
/*
    * @description:
    * @param {Object} json 服务端发过来的数据
    * @param {String} name 导出Excel文件名字
   
    * @param {String} titleArr 导出Excel表头
   
    * @param {String} sheetName 导出sheetName名字
    * @return:
    */
export default function exportExcel(json, name, titleArr, sheetName) {
	/* convert state to workbook */
	var data = new Array();
	// var keyArray = new Array();
	const getLength = function (obj) {
		var count = 0;
		for (var i in obj) {
			if (obj.hasOwnProperty(i)) {
				count++;
			}
		}
		return count;
	};
	for (const key1 in json) {
		if (json.hasOwnProperty(key1)) {
			const element = json[key1];
			var rowDataArray = new Array();
			for (const key2 in element) {
				if (element.hasOwnProperty(key2)) {
					const element2 = element[key2];
					rowDataArray.push(element2);
					// if (keyArray.length < getLength(element)) {
					// 	keyArray.push(key2);
					// }
				}
			}
			data.push(rowDataArray);
		}
	}
	// keyArray为英文字段表头
	data.splice(0, 0, titleArr);
	console.log('data', data);
	const ws = utils.aoa_to_sheet(data);
	const wb = utils.book_new();
	// 此处隐藏英文字段表头
	// var wsrows = [{ hidden: true }];
	// ws['!rows'] = wsrows; // ws - worksheet
	utils.book_append_sheet(wb, ws, sheetName);
	/* generate file and send to client */
	writeFile(wb, name + '.xlsx');
}
